﻿USE [RestaurantManagement]
GO
/****** Object:  StoredProcedure [dbo].[Get_All_Provinces_ByIsActive]    Script Date: 04/21/2013 18:22:41 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Nguyễn Đức Thắng>
-- Create date: <15/03/2013>
-- Get_All_Restaurants
-- =============================================
CREATE procedure [dbo].[Get_All_Stocks_ByIsActive]
	@IsActive bit
AS
BEGIN
	SELECT StockID,
			StockCode,
			StockName,
			Description,
			RestaurantID,
			IsActive
	 FROM  Production.[Stock]
	WHERE  IsActive = @IsActive
END
